Tabela Insurer

Definicja tabeli Insurer

Name

Insurer

Code

Insurer

Comment

 


Lista kolumn tabeli Insurer

Name

Code

InsurID

InsurID

Code

Code

ShortName

ShortName

FullName

FullName

Active

Active

StartDT

StartDT

StopDT

StopDT

Comments

Comments

AdmCodeID

AdmCodeID


Kolumna InsurID tabeli Insurer

Definicja kolumny InsurID tabeli Insurer

Name

InsurID

Code

InsurID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

depreciated


Kolumna Code tabeli Insurer

Definicja kolumny Code tabeli Insurer

Name

Code

Code

Code

Data Type

VARCHAR2(13)

Mandatory

No

Comment

PL: Kod wiersza
EN: Record's code
DE: Der code des Rekord


Kolumna ShortName tabeli Insurer

Definicja kolumny ShortName tabeli Insurer

Name

ShortName

Code

ShortName

Data Type

VARCHAR2(64)

Mandatory

No

Comment

PL: Skrócona nazwa wiersza
EN: Record's short name
DE: Der kurz Name des Rekord


Kolumna FullName tabeli Insurer

Definicja kolumny FullName tabeli Insurer

Name

FullName

Code

FullName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

PL: Pelna nazwa wiersza
EN: Record's full name
DE: Der voll Name des Rekord


Kolumna Active tabeli Insurer

Definicja kolumny Active tabeli Insurer

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Kolumna StartDT tabeli Insurer

Definicja kolumny StartDT tabeli Insurer

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli Insurer

Definicja kolumny StopDT tabeli Insurer

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna Comments tabeli Insurer

Definicja kolumny Comments tabeli Insurer

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna AdmCodeID tabeli Insurer

Definicja kolumny AdmCodeID tabeli Insurer

Name

AdmCodeID

Code

AdmCodeID

Data Type

NUMBER(10)

Mandatory

No

Comment

Identyfikator dla kodu terytorialnego wlasciwego dla danego ubezpieczyciela


Lista kluczy tabeli Insurer

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Insurer

Definicja klucza Identifier_1 tabeli Insurer

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment